Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	32200183
Missing cells	47159106
Missing cells (%)	7.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.6 GiB
Average record size in memory	153.0 B

Variable types

Numeric	11
Categorical	7
Boolean	1
Unsupported	1

Alerts

`game_start_time` has a high cardinality: 10524736 distinct values	High cardinality
`map_name` has a high cardinality: 10416 distinct values	High cardinality
`player_login` has a high cardinality: 270420 distinct values	High cardinality
`game_id` is highly correlated with `map_id` and 1 other fields	High correlation
`game_total_players` is highly correlated with `player_starting_spot`	High correlation
`map_id` is highly correlated with `game_id`	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`player_id` is highly correlated with `game_id`	High correlation
`player_starting_spot` is highly correlated with `game_total_players`	High correlation
`before_rating` is highly correlated with `after_rating`	High correlation
`after_rating` is highly correlated with `before_rating`	High correlation
`game_id` is highly correlated with `map_id` and 1 other fields	High correlation
`game_total_players` is highly correlated with `player_starting_spot`	High correlation
`map_id` is highly correlated with `game_id`	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`player_id` is highly correlated with `game_id`	High correlation
`player_starting_spot` is highly correlated with `game_total_players`	High correlation
`before_rating` is highly correlated with `after_rating`	High correlation
`after_rating` is highly correlated with `before_rating`	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`before_rating` is highly correlated with `after_rating`	High correlation
`after_rating` is highly correlated with `before_rating`	High correlation
`game_id` is highly correlated with `game_validity` and 3 other fields	High correlation
`game_validity` is highly correlated with `game_id` and 2 other fields	High correlation
`game_featuremod_name` is highly correlated with `game_validity`	High correlation
`game_total_players` is highly correlated with `game_validity` and 2 other fields	High correlation
`map_id` is highly correlated with `game_id` and 2 other fields	High correlation
`map_width` is highly correlated with `map_height`	High correlation
`map_height` is highly correlated with `map_width`	High correlation
`player_id` is highly correlated with `game_id` and 1 other fields	High correlation
`player_starting_spot` is highly correlated with `game_total_players`	High correlation
`player_result` is highly correlated with `game_id` and 2 other fields	High correlation
`before_rating` is highly correlated with `after_rating`	High correlation
`after_rating` is highly correlated with `before_rating`	High correlation
`map_id` has 2564564 (8.0%) missing values	Missing
`map_name` has 2564564 (8.0%) missing values	Missing
`map_width` has 2564564 (8.0%) missing values	Missing
`map_height` has 2564564 (8.0%) missing values	Missing
`after_rating` has 18327390 (56.9%) missing values	Missing
`leaderboard_ids` has 18571835 (57.7%) missing values	Missing
`game_duration_minutes` is highly skewed (γ1 = 64.35305983)	Skewed
`leaderboard_ids` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`player_team` has 623788 (1.9%) zeros	Zeros
`before_rating` has 5175780 (16.1%) zeros	Zeros

Reproduction

Analysis started	2022-07-28 01:44:34.918806
Analysis finished	2022-07-28 02:41:33.737222
Duration	56 minutes and 58.82 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

game_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10811711
Distinct (%)	33.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9412086.94

Minimum	535
Maximum	17405720
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	535
5-th percentile	1180473
Q1	5362658
median	9712520
Q3	13652441.5
95-th percentile	16644375
Maximum	17405720
Range	17405185
Interquartile range (IQR)	8289783.5

Descriptive statistics

Standard deviation	4896118.822
Coefficient of variation (CV)	0.5201948147
Kurtosis	-1.114986037
Mean	9412086.94
Median Absolute Deviation (MAD)	4106763
Skewness	-0.1692315475
Sum	3.030709219 × 10¹⁴
Variance	2.397197952 × 10¹³
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12200473	22	< 0.1%
5039109	17	< 0.1%
5048433	17	< 0.1%
5372349	17	< 0.1%
5496354	17	< 0.1%
5037683	17	< 0.1%
5444278	17	< 0.1%
5479980	17	< 0.1%
11552500	16	< 0.1%
12792113	16	< 0.1%
Other values (10811701)	32200010	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
535	6	< 0.1%
536	3	< 0.1%
547	4	< 0.1%
549	2	< 0.1%
552	2	< 0.1%
555	6	< 0.1%
557	6	< 0.1%
562	12	< 0.1%
569	6	< 0.1%
573	6	< 0.1%

Value	Count	Frequency (%)
17405720	1	< 0.1%
17405714	1	< 0.1%
17405713	1	< 0.1%
17405712	1	< 0.1%
17405711	1	< 0.1%
17405709	1	< 0.1%
17405708	1	< 0.1%
17405707	3	< 0.1%
17405706	1	< 0.1%
17405704	1	< 0.1%

game_start_time
Categorical

HIGH CARDINALITY

Distinct	10524736
Distinct (%)	32.7%
Missing	0
Missing (%)	0.0%
Memory size	245.7 MiB

2017-05-10 20:15:44 UTC	15623
2020-02-16 20:35:55 UTC	35
2021-09-18 17:18:55 UTC	34
2021-10-07 21:32:19 UTC	34
2021-10-03 17:48:34 UTC	32
Other values (10524731)	32184425

Length

Max length	23
Median length	23
Mean length	23
Min length	23

Characters and Unicode

Total characters	740604209
Distinct characters	16
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4211311 ?
Unique (%)	13.1%

Sample

1st row	2022-06-30 23:59:58 UTC
2nd row	2022-06-30 23:59:44 UTC
3rd row	2022-06-30 23:58:34 UTC
4th row	2022-06-30 23:58:34 UTC
5th row	2022-06-30 23:58:34 UTC

Common Values

Value	Count	Frequency (%)
2017-05-10 20:15:44 UTC	15623	< 0.1%
2020-02-16 20:35:55 UTC	35	< 0.1%
2021-09-18 17:18:55 UTC	34	< 0.1%
2021-10-07 21:32:19 UTC	34	< 0.1%
2021-10-03 17:48:34 UTC	32	< 0.1%
2021-10-20 19:10:50 UTC	32	< 0.1%
2022-05-11 18:10:39 UTC	32	< 0.1%
2020-11-19 20:03:42 UTC	32	< 0.1%
2020-08-23 17:10:04 UTC	31	< 0.1%
2021-10-20 19:43:37 UTC	31	< 0.1%
Other values (10524726)	32184267	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
utc	32200183	33.3%
2020-11-21	23223	< 0.1%
2020-11-22	23175	< 0.1%
2022-04-10	22887	< 0.1%
2020-12-05	22639	< 0.1%
2020-12-06	22634	< 0.1%
2020-11-14	22597	< 0.1%
2020-11-29	22168	< 0.1%
2020-11-28	22125	< 0.1%
2020-11-07	21945	< 0.1%
Other values (90172)	64196973	66.5%

Most occurring characters

Value	Count	Frequency (%)
0	106976755	14.4%
2	97269828	13.1%
1	89292916	12.1%
-	64400366	8.7%
	64400366	8.7%
:	64400366	8.7%
U	32200183	4.3%
T	32200183	4.3%
C	32200183	4.3%
3	29990460	4.0%
Other values (6)	127272603	17.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	450802562	60.9%
Uppercase Letter	96600549	13.0%
Dash Punctuation	64400366	8.7%
Space Separator	64400366	8.7%
Other Punctuation	64400366	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	106976755	23.7%
2	97269828	21.6%
1	89292916	19.8%
3	29990460	6.7%
5	27588247	6.1%
4	27422888	6.1%
8	18763496	4.2%
9	18719237	4.2%
7	17671426	3.9%
6	17107309	3.8%

Uppercase Letter

Value	Count	Frequency (%)
U	32200183	33.3%
T	32200183	33.3%
C	32200183	33.3%

Dash Punctuation

Value	Count	Frequency (%)
-	64400366	100.0%

Space Separator

Value	Count	Frequency (%)
	64400366	100.0%

Other Punctuation

Value	Count	Frequency (%)
:	64400366	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	644003660	87.0%
Latin	96600549	13.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	106976755	16.6%
2	97269828	15.1%
1	89292916	13.9%
-	64400366	10.0%
	64400366	10.0%
:	64400366	10.0%
3	29990460	4.7%
5	27588247	4.3%
4	27422888	4.3%
8	18763496	2.9%
Other values (3)	53497972	8.3%

Latin

Value	Count	Frequency (%)
U	32200183	33.3%
T	32200183	33.3%
C	32200183	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	740604209	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	106976755	14.4%
2	97269828	13.1%
1	89292916	12.1%
-	64400366	8.7%
	64400366	8.7%
:	64400366	8.7%
U	32200183	4.3%
T	32200183	4.3%
C	32200183	4.3%
3	29990460	4.0%
Other values (6)	127272603	17.2%

game_duration_minutes
Real number (ℝ_≥0)

SKEWED

Distinct	13189
Distinct (%)	< 0.1%
Missing	1068
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	41.66520399

Minimum	0
Maximum	29847.3
Zeros	8929
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	0
5-th percentile	1.4
Q1	15.7
median	34.6
Q3	55.9
95-th percentile	101.2
Maximum	29847.3
Range	29847.3
Interquartile range (IQR)	40.2

Descriptive statistics

Standard deviation	56.67939479
Coefficient of variation (CV)	1.360353229
Kurtosis	17060.16284
Mean	41.66520399
Median Absolute Deviation (MAD)	19.9
Skewness	64.35305983
Sum	1341582695
Variance	3212.553793
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1	292520	0.9%
0.8	133663	0.4%
0.5	132339	0.4%
0.6	128726	0.4%
1.1	122848	0.4%
0.7	121665	0.4%
1.4	110410	0.3%
0.9	109132	0.3%
1.6	104567	0.3%
1.9	100897	0.3%
Other values (13179)	30842348	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	8929	< 0.1%
0.1	292520	0.9%
0.2	20218	0.1%
0.3	78961	0.2%
0.4	94161	0.3%
0.5	132339	0.4%
0.6	128726	0.4%
0.7	121665	0.4%
0.8	133663	0.4%
0.9	109132	0.3%

Value	Count	Frequency (%)
29847.3	1	< 0.1%
25822.2	1	< 0.1%
24102.8	8	< 0.1%
20199.3	1	< 0.1%
20100.2	1	< 0.1%
16667	1	< 0.1%
14541.2	1	< 0.1%
14539.2	1	< 0.1%
12975.5	12	< 0.1%
11954.3	1	< 0.1%

game_validity
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	245.7 MiB

VALID	14589108
TOO_MANY_DESYNCS	3255349
UNKNOWN_RESULT	2738617
BAD_MOD	2502835
TOO_SHORT	1682861
Other values (18)	7431413

Length

Max length	23
Median length	21
Mean length	9.485424601
Min length	5

Characters and Unicode

Total characters	305432408
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UNKNOWN_RESULT
2nd row	COOP_NOT_RANKED
3rd row	VALID
4th row	VALID
5th row	VALID

Common Values

Value	Count	Frequency (%)
VALID	14589108	45.3%
TOO_MANY_DESYNCS	3255349	10.1%
UNKNOWN_RESULT	2738617	8.5%
BAD_MOD	2502835	7.8%
TOO_SHORT	1682861	5.2%
BAD_UNIT_RESTRICTIONS	1415966	4.4%
HAS_AI	1327815	4.1%
SINGLE_PLAYER	1007129	3.1%
UNEVEN_TEAMS_NOT_RANKED	892808	2.8%
BAD_MAP	718731	2.2%
Other values (13)	2068964	6.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
valid	14589108	45.3%
too_many_desyncs	3255349	10.1%
unknown_result	2738617	8.5%
bad_mod	2502835	7.8%
too_short	1682861	5.2%
bad_unit_restrictions	1415966	4.4%
has_ai	1327815	4.1%
single_player	1007129	3.1%
uneven_teams_not_ranked	892808	2.8%
bad_map	718731	2.2%
Other values (13)	2068964	6.4%

Most occurring characters

Value	Count	Frequency (%)
A	31178518	10.2%
D	27826304	9.1%
N	25856667	8.5%
_	25463095	8.3%
I	22766781	7.5%
O	22354437	7.3%
L	20332707	6.7%
T	17733311	5.8%
S	17594817	5.8%
V	15825827	5.2%
Other values (14)	78499944	25.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	279969313	91.7%
Connector Punctuation	25463095	8.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	31178518	11.1%
D	27826304	9.9%
N	25856667	9.2%
I	22766781	8.1%
O	22354437	8.0%
L	20332707	7.3%
T	17733311	6.3%
S	17594817	6.3%
V	15825827	5.7%
E	15533957	5.5%
Other values (13)	62965987	22.5%

Connector Punctuation

Value	Count	Frequency (%)
_	25463095	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	279969313	91.7%
Common	25463095	8.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	31178518	11.1%
D	27826304	9.9%
N	25856667	9.2%
I	22766781	8.1%
O	22354437	8.0%
L	20332707	7.3%
T	17733311	6.3%
S	17594817	6.3%
V	15825827	5.7%
E	15533957	5.5%
Other values (13)	62965987	22.5%

Common

Value	Count	Frequency (%)
_	25463095	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	305432408	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	31178518	10.2%
D	27826304	9.1%
N	25856667	8.5%
_	25463095	8.3%
I	22766781	7.5%
O	22354437	7.3%
L	20332707	6.7%
T	17733311	5.8%
S	17594817	5.8%
V	15825827	5.2%
Other values (14)	78499944	25.7%

game_featuremod_name
Categorical

HIGH CORRELATION

Distinct	15
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	245.7 MiB

FAF	26326332
Ladder1v1	2286435
Coop	1897527
Nomads	552158
Phantom-X	353433
Other values (10)	784298

Length

Max length	16
Median length	3
Mean length	3.830369349
Min length	3

Characters and Unicode

Total characters	123338594
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FAF
2nd row	Coop
3rd row	FAF
4th row	FAF
5th row	FAF

Common Values

Value	Count	Frequency (%)
FAF	26326332	81.8%
Ladder1v1	2286435	7.1%
Coop	1897527	5.9%
Nomads	552158	1.7%
Phantom-X	353433	1.1%
Xtreme Wars	348758	1.1%
FAF Beta Balance	202126	0.6%
FAF Develop	87119	0.3%
Equilibrium	47860	0.1%
Murder Party	33760	0.1%
Other values (5)	64675	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
faf	26615577	80.4%
ladder1v1	2286435	6.9%
coop	1897527	5.7%
nomads	552158	1.7%
phantom-x	353433	1.1%
xtreme	348758	1.1%
wars	348758	1.1%
beta	202126	0.6%
balance	202126	0.6%
develop	87119	0.3%
Other values (11)	217795	0.7%

Most occurring characters

Value	Count	Frequency (%)
F	53231154	43.2%
A	26637034	21.6%
d	5161480	4.2%
o	4852048	3.9%
1	4572870	3.7%
a	4260963	3.5%
e	3608781	2.9%
r	3179054	2.6%
v	2373554	1.9%
L	2307892	1.9%
Other values (30)	13153764	10.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	86714153	70.3%
Lowercase Letter	30786509	25.0%
Decimal Number	4572870	3.7%
Space Separator	911629	0.7%
Dash Punctuation	353433	0.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	5161480	16.8%
o	4852048	15.8%
a	4260963	13.8%
e	3608781	11.7%
r	3179054	10.3%
v	2373554	7.7%
p	2009152	6.5%
m	1304901	4.2%
t	975163	3.2%
s	946879	3.1%
Other values (12)	2114534	6.9%

Uppercase Letter

Value	Count	Frequency (%)
F	53231154	61.4%
A	26637034	30.7%
L	2307892	2.7%
C	1922033	2.2%
X	702191	0.8%
N	552158	0.6%
B	425709	0.5%
P	387193	0.4%
W	348758	0.4%
D	89811	0.1%
Other values (5)	110220	0.1%

Decimal Number

Value	Count	Frequency (%)
1	4572870	100.0%

Space Separator

Value	Count	Frequency (%)
	911629	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	353433	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	117500662	95.3%
Common	5837932	4.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	53231154	45.3%
A	26637034	22.7%
d	5161480	4.4%
o	4852048	4.1%
a	4260963	3.6%
e	3608781	3.1%
r	3179054	2.7%
v	2373554	2.0%
L	2307892	2.0%
p	2009152	1.7%
Other values (27)	9879550	8.4%

Common

Value	Count	Frequency (%)
1	4572870	78.3%
	911629	15.6%
-	353433	6.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	123338594	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	53231154	43.2%
A	26637034	21.6%
d	5161480	4.2%
o	4852048	3.9%
1	4572870	3.7%
a	4260963	3.5%
e	3608781	2.9%
r	3179054	2.6%
v	2373554	1.9%
L	2307892	1.9%
Other values (30)	13153764	10.7%

game_total_players
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.9791081

Minimum	1
Maximum	22
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	6
Q3	8
95-th percentile	12
Maximum	22
Range	21
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	4.045415817
Coefficient of variation (CV)	0.676591851
Kurtosis	-1.233475966
Mean	5.9791081
Median Absolute Deviation (MAD)	4
Skewness	0.3124295499
Sum	192528375
Variance	16.36538913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
8	6709296	20.8%
2	6424048	20.0%
12	5615220	17.4%
1	4454367	13.8%
4	2324252	7.2%
6	2302668	7.2%
3	1736388	5.4%
10	1606660	5.0%
5	355425	1.1%
16	210592	0.7%
Other values (8)	461267	1.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	4454367	13.8%
2	6424048	20.0%
3	1736388	5.4%
4	2324252	7.2%
5	355425	1.1%
6	2302668	7.2%
7	183337	0.6%
8	6709296	20.8%
9	84348	0.3%
10	1606660	5.0%

Value	Count	Frequency (%)
22	22	< 0.1%
17	119	< 0.1%
16	210592	0.7%
15	8880	< 0.1%
14	136710	0.4%
13	7514	< 0.1%
12	5615220	17.4%
11	40337	0.1%
10	1606660	5.0%
9	84348	0.3%

map_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	19024
Distinct (%)	0.1%
Missing	2564564
Missing (%)	8.0%
Infinite	0
Infinite (%)	0.0%
Mean	5935.585321

Minimum	1
Maximum	22655
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	1
5-th percentile	156
Q1	566
median	4704
Q3	8972
95-th percentile	17709
Maximum	22655
Range	22654
Interquartile range (IQR)	8406

Descriptive statistics

Standard deviation	5856.162519
Coefficient of variation (CV)	0.9866192132
Kurtosis	0.03161374621
Mean	5935.585321
Median Absolute Deviation (MAD)	4138
Skewness	0.9641361308
Sum	1.759047451 × 10¹¹
Variance	34294639.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
560	2615634	8.1%
15545	1135800	3.5%
246	920487	2.9%
3658	832120	2.6%
3660	737759	2.3%
21131	690359	2.1%
10061	668616	2.1%
566	448505	1.4%
9698	400403	1.2%
558	305865	0.9%
Other values (19014)	20880071	64.8%
(Missing)	2564564	8.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	13813	< 0.1%
2	10393	< 0.1%
3	405	< 0.1%
4	6620	< 0.1%
5	105276	0.3%
6	295	< 0.1%
7	2967	< 0.1%
8	75604	0.2%
9	5096	< 0.1%
11	121	< 0.1%

Value	Count	Frequency (%)
22655	2	< 0.1%
22654	9	< 0.1%
22653	1	< 0.1%
22652	6	< 0.1%
22651	1	< 0.1%
22647	9	< 0.1%
22643	19	< 0.1%
22642	10	< 0.1%
22641	12	< 0.1%
22640	194	< 0.1%

map_name
Categorical

HIGH CARDINALITY
MISSING

Distinct	10416
Distinct (%)	< 0.1%
Missing	2564564
Missing (%)	8.0%
Memory size	245.7 MiB

Seton's Clutch	2617077
DualGap Adaptive	2006053
gap of rohan	920487
DualGap_fix_adaptive	883097
Astro Crater Battles	832120
Other values (10411)	22376785

Length

Max length	84
Median length	49
Mean length	17.39278501
Min length	1

Characters and Unicode

Total characters	515445950
Distinct characters	84
Distinct categories	12 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	177 ?
Unique (%)	< 0.1%

Sample

1st row	Hold the line
2nd row	Desert Gap
3rd row	Desert Gap
4th row	Desert Gap
5th row	Desert Gap

Common Values

Value	Count	Frequency (%)
Seton's Clutch	2617077	8.1%
DualGap Adaptive	2006053	6.2%
gap of rohan	920487	2.9%
DualGap_fix_adaptive	883097	2.7%
Astro Crater Battles	832120	2.6%
Astro Crater Battles 4x4 v2	754646	2.3%
Fields of Isis	448505	1.4%
Astro Crater Battles 4x4 rich_v2	400403	1.2%
Open Palms	305865	0.9%
Twin Rivers	293313	0.9%
Other values (10406)	20174053	62.7%
(Missing)	2564564	8.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
crater	3180320	3.9%
astro	3146680	3.8%
adaptive	2885258	3.5%
battles	2850698	3.5%
clutch	2841900	3.5%
of	2835426	3.5%
seton's	2654494	3.2%
dualgap	2225553	2.7%
gap	2102836	2.6%
4x4	1776719	2.2%
Other values (7254)	55241004	67.6%

Most occurring characters

Value	Count	Frequency (%)
	52382117	10.2%
a	44768237	8.7%
e	35489075	6.9%
t	33157370	6.4%
s	26851623	5.2%
o	25505555	4.9%
r	25399317	4.9%
l	23304820	4.5%
i	22016034	4.3%
n	18719516	3.6%
Other values (74)	207852286	40.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	354596443	68.8%
Uppercase Letter	72803204	14.1%
Space Separator	52382117	10.2%
Decimal Number	23000960	4.5%
Connector Punctuation	7023418	1.4%
Other Punctuation	4529251	0.9%
Dash Punctuation	998338	0.2%
Open Punctuation	53152	< 0.1%
Close Punctuation	52968	< 0.1%
Math Symbol	5876	< 0.1%
Other values (2)	223	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	44768237	12.6%
e	35489075	10.0%
t	33157370	9.4%
s	26851623	7.6%
o	25505555	7.2%
r	25399317	7.2%
l	23304820	6.6%
i	22016034	6.2%
n	18719516	5.3%
v	15832110	4.5%
Other values (16)	83552786	23.6%

Uppercase Letter

Value	Count	Frequency (%)
A	8514460	11.7%
C	8398273	11.5%
S	6850281	9.4%
D	6142574	8.4%
G	5328186	7.3%
B	5236233	7.2%
P	5004666	6.9%
F	3802549	5.2%
T	3663782	5.0%
R	3524706	4.8%
Other values (16)	16337494	22.4%

Decimal Number

Value	Count	Frequency (%)
4	5938207	25.8%
2	4459873	19.4%
1	3235239	14.1%
5	3123757	13.6%
0	2359533	10.3%
3	1893312	8.2%
6	1094216	4.8%
8	419973	1.8%
7	329065	1.4%
9	147785	0.6%

Other Punctuation

Value	Count	Frequency (%)
'	3313931	73.2%
.	1102756	24.3%
&	56403	1.2%
!	32059	0.7%
,	12464	0.3%
;	10390	0.2%
\	1151	< 0.1%
:	96	< 0.1%
/	1	< 0.1%

Math Symbol

Value	Count	Frequency (%)
+	3648	62.1%
>	1097	18.7%
<	1097	18.7%
\|	34	0.6%

Open Punctuation

Value	Count	Frequency (%)
(	46052	86.6%
[	7100	13.4%

Close Punctuation

Value	Count	Frequency (%)
)	45868	86.6%
]	7100	13.4%

Space Separator

Value	Count	Frequency (%)
	52382117	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	7023418	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	998338	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	195	100.0%

Control

Value	Count	Frequency (%)
	28	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	427399647	82.9%
Common	88046303	17.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	44768237	10.5%
e	35489075	8.3%
t	33157370	7.8%
s	26851623	6.3%
o	25505555	6.0%
r	25399317	5.9%
l	23304820	5.5%
i	22016034	5.2%
n	18719516	4.4%
v	15832110	3.7%
Other values (42)	156355990	36.6%

Common

Value	Count	Frequency (%)
	52382117	59.5%
_	7023418	8.0%
4	5938207	6.7%
2	4459873	5.1%
'	3313931	3.8%
1	3235239	3.7%
5	3123757	3.5%
0	2359533	2.7%
3	1893312	2.2%
.	1102756	1.3%
Other values (22)	3214160	3.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	515445950	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	52382117	10.2%
a	44768237	8.7%
e	35489075	6.9%
t	33157370	6.4%
s	26851623	5.2%
o	25505555	4.9%
r	25399317	4.9%
l	23304820	4.5%
i	22016034	4.3%
n	18719516	3.6%
Other values (74)	207852286	40.3%

map_width
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	2564564
Missing (%)	8.0%
Infinite	0
Infinite (%)	0.0%
Mean	749.9935907

Minimum	10
Maximum	4096
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	10
5-th percentile	256
Q1	512
median	512
Q3	1024
95-th percentile	1024
Maximum	4096
Range	4086
Interquartile range (IQR)	512

Descriptive statistics

Standard deviation	455.0894438
Coefficient of variation (CV)	0.6067911106
Kurtosis	23.7068909
Mean	749.9935907
Median Absolute Deviation (MAD)	0
Skewness	3.847492419
Sum	2.222652431 × 10¹⁰
Variance	207106.4019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=9)

Value	Count	Frequency (%)
512	15899183	49.4%
1024	10953376	34.0%
256	1858802	5.8%
2048	660228	2.1%
4096	254095	0.8%
128	7459	< 0.1%
64	2457	< 0.1%
10	17	< 0.1%
20	2	< 0.1%
(Missing)	2564564	8.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	17	< 0.1%
20	2	< 0.1%
64	2457	< 0.1%
128	7459	< 0.1%
256	1858802	5.8%
512	15899183	49.4%
1024	10953376	34.0%
2048	660228	2.1%
4096	254095	0.8%

Value	Count	Frequency (%)
4096	254095	0.8%
2048	660228	2.1%
1024	10953376	34.0%
512	15899183	49.4%
256	1858802	5.8%
128	7459	< 0.1%
64	2457	< 0.1%
20	2	< 0.1%
10	17	< 0.1%

map_height
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11
Distinct (%)	< 0.1%
Missing	2564564
Missing (%)	8.0%
Infinite	0
Infinite (%)	0.0%
Mean	747.4014564

Minimum	10
Maximum	4096
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	10
5-th percentile	256
Q1	512
median	512
Q3	1024
95-th percentile	1024
Maximum	4096
Range	4086
Interquartile range (IQR)	512

Descriptive statistics

Standard deviation	454.1259459
Coefficient of variation (CV)	0.6076064503
Kurtosis	23.86034892
Mean	747.4014564
Median Absolute Deviation (MAD)	0
Skewness	3.859458393
Sum	2.21497048 × 10¹⁰
Variance	206230.3747
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
512	15965512	49.6%
1024	10861671	33.7%
256	1892465	5.9%
2048	650577	2.0%
4096	252667	0.8%
64	6615	< 0.1%
128	5982	< 0.1%
400	109	< 0.1%
10	17	< 0.1%
960	2	< 0.1%
(Missing)	2564564	8.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10	17	< 0.1%
20	2	< 0.1%
64	6615	< 0.1%
128	5982	< 0.1%
256	1892465	5.9%
400	109	< 0.1%
512	15965512	49.6%
960	2	< 0.1%
1024	10861671	33.7%
2048	650577	2.0%

Value	Count	Frequency (%)
4096	252667	0.8%
2048	650577	2.0%
1024	10861671	33.7%
960	2	< 0.1%
512	15965512	49.6%
400	109	< 0.1%
256	1892465	5.9%
128	5982	< 0.1%
64	6615	< 0.1%
20	2	< 0.1%

player_id
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	270421
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	191303.4255

Minimum	5
Maximum	449760
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	5
5-th percentile	14746
Q1	76850
median	186952
Q3	298017
95-th percentile	399806
Maximum	449760
Range	449755
Interquartile range (IQR)	221167

Descriptive statistics

Standard deviation	126030.3201
Coefficient of variation (CV)	0.6587980313
Kurtosis	-1.14843654
Mean	191303.4255
Median Absolute Deviation (MAD)	110479
Skewness	0.1976396293
Sum	6.160005311 × 10¹²
Variance	1.588364159 × 10¹⁰
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
116558	23601	0.1%
65327	19063	0.1%
22745	17156	0.1%
50679	17073	0.1%
361	16290	0.1%
14492	15002	< 0.1%
73532	14357	< 0.1%
34434	14019	< 0.1%
21234	13236	< 0.1%
2642	13171	< 0.1%
Other values (270411)	32037215	99.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
5	625	< 0.1%
6	187	< 0.1%
7	7	< 0.1%
9	33	< 0.1%
10	26	< 0.1%
20	1	< 0.1%
22	1263	< 0.1%
23	3452	< 0.1%
24	4854	< 0.1%
25	56	< 0.1%

Value	Count	Frequency (%)
449760	1	< 0.1%
449758	2	< 0.1%
449756	1	< 0.1%
449755	1	< 0.1%
449754	1	< 0.1%
449753	1	< 0.1%
449752	1	< 0.1%
449749	1	< 0.1%
449747	2	< 0.1%
449744	3	< 0.1%

player_login
Categorical

HIGH CARDINALITY

Distinct	270420
Distinct (%)	0.8%
Missing	557
Missing (%)	< 0.1%
Memory size	245.7 MiB

coca	23601
Photon	19063
Chosen	17156
DDDX	17073
Warner-Valholl	16290
Other values (270415)	32106443

Length

Max length	20
Median length	17
Mean length	8.650968803
Min length	1

Characters and Unicode

Total characters	278557960
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	27753 ?
Unique (%)	0.1%

Sample

1st row	Walgreens
2nd row	Starcruiser
3rd row	ourubapu
4th row	Enzord_Rocka
5th row	Defiant

Common Values

Value	Count	Frequency (%)
coca	23601	0.1%
Photon	19063	0.1%
Chosen	17156	0.1%
DDDX	17073	0.1%
Warner-Valholl	16290	0.1%
alexanderberlin	15002	< 0.1%
K240	14357	< 0.1%
HighLander-TX	14019	< 0.1%
dardan	13236	< 0.1%
nemir	13171	< 0.1%
Other values (270410)	32036658	99.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
coca	23601	0.1%
photon	19063	0.1%
chosen	17156	0.1%
dddx	17073	0.1%
warner-valholl	16290	0.1%
alexanderberlin	15002	< 0.1%
k240	14357	< 0.1%
highlander-tx	14019	< 0.1%
dardan	13236	< 0.1%
nemir	13171	< 0.1%
Other values (269293)	32041332	99.5%

Most occurring characters

Value	Count	Frequency (%)
a	22075532	7.9%
e	22061727	7.9%
o	17886907	6.4%
r	17515944	6.3%
i	15684231	5.6%
n	14090013	5.1%
t	11158434	4.0%
l	11034672	4.0%
s	10550598	3.8%
u	7474469	2.7%
Other values (56)	129025433	46.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	210405473	75.5%
Uppercase Letter	47656981	17.1%
Decimal Number	15404767	5.5%
Connector Punctuation	4135947	1.5%
Dash Punctuation	949941	0.3%
Space Separator	4674	< 0.1%
Other Punctuation	177	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	22075532	10.5%
e	22061727	10.5%
o	17886907	8.5%
r	17515944	8.3%
i	15684231	7.5%
n	14090013	6.7%
t	11158434	5.3%
l	11034672	5.2%
s	10550598	5.0%
u	7474469	3.6%
Other values (16)	60872946	28.9%

Uppercase Letter

Value	Count	Frequency (%)
S	4267631	9.0%
A	3303587	6.9%
M	3055686	6.4%
T	2906101	6.1%
D	2858187	6.0%
R	2511761	5.3%
B	2500258	5.2%
C	2439644	5.1%
N	2106631	4.4%
P	2027852	4.3%
Other values (16)	19679643	41.3%

Decimal Number

Value	Count	Frequency (%)
1	2821892	18.3%
0	2351878	15.3%
2	2001556	13.0%
3	1574562	10.2%
4	1285602	8.3%
9	1258431	8.2%
7	1183640	7.7%
8	1012914	6.6%
5	1002128	6.5%
6	912164	5.9%

Connector Punctuation

Value	Count	Frequency (%)
_	4135947	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	949941	100.0%

Space Separator

Value	Count	Frequency (%)
	4674	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	177	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	258062454	92.6%
Common	20495506	7.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	22075532	8.6%
e	22061727	8.5%
o	17886907	6.9%
r	17515944	6.8%
i	15684231	6.1%
n	14090013	5.5%
t	11158434	4.3%
l	11034672	4.3%
s	10550598	4.1%
u	7474469	2.9%
Other values (42)	108529927	42.1%

Common

Value	Count	Frequency (%)
_	4135947	20.2%
1	2821892	13.8%
0	2351878	11.5%
2	2001556	9.8%
3	1574562	7.7%
4	1285602	6.3%
9	1258431	6.1%
7	1183640	5.8%
8	1012914	4.9%
5	1002128	4.9%
Other values (4)	1866956	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	278557960	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	22075532	7.9%
e	22061727	7.9%
o	17886907	6.4%
r	17515944	6.3%
i	15684231	5.6%
n	14090013	5.1%
t	11158434	4.0%
l	11034672	4.0%
s	10550598	3.8%
u	7474469	2.7%
Other values (56)	129025433	46.3%

player_faction
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	245.7 MiB

UEF	10865422
Cybran	9133088
Aeon	5710582
Seraphim	4497824
Other	1993267

Length

Max length	8
Median length	6
Mean length	4.85047085
Min length	3

Characters and Unicode

Total characters	156186049
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UEF
2nd row	Cybran
3rd row	UEF
4th row	UEF
5th row	UEF

Common Values

Value	Count	Frequency (%)
UEF	10865422	33.7%
Cybran	9133088	28.4%
Aeon	5710582	17.7%
Seraphim	4497824	14.0%
Other	1993267	6.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
uef	10865422	33.7%
cybran	9133088	28.4%
aeon	5710582	17.7%
seraphim	4497824	14.0%
other	1993267	6.2%

Most occurring characters

Value	Count	Frequency (%)
r	15624179	10.0%
n	14843670	9.5%
a	13630912	8.7%
e	12201673	7.8%
U	10865422	7.0%
F	10865422	7.0%
E	10865422	7.0%
C	9133088	5.8%
y	9133088	5.8%
b	9133088	5.8%
Other values (9)	39890085	25.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	102255022	65.5%
Uppercase Letter	53931027	34.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	15624179	15.3%
n	14843670	14.5%
a	13630912	13.3%
e	12201673	11.9%
y	9133088	8.9%
b	9133088	8.9%
h	6491091	6.3%
o	5710582	5.6%
p	4497824	4.4%
i	4497824	4.4%
Other values (2)	6491091	6.3%

Uppercase Letter

Value	Count	Frequency (%)
U	10865422	20.1%
F	10865422	20.1%
E	10865422	20.1%
C	9133088	16.9%
A	5710582	10.6%
S	4497824	8.3%
O	1993267	3.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	156186049	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	15624179	10.0%
n	14843670	9.5%
a	13630912	8.7%
e	12201673	7.8%
U	10865422	7.0%
F	10865422	7.0%
E	10865422	7.0%
C	9133088	5.8%
y	9133088	5.8%
b	9133088	5.8%
Other values (9)	39890085	25.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	156186049	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	15624179	10.0%
n	14843670	9.5%
a	13630912	8.7%
e	12201673	7.8%
U	10865422	7.0%
F	10865422	7.0%
E	10865422	7.0%
C	9133088	5.8%
y	9133088	5.8%
b	9133088	5.8%
Other values (9)	39890085	25.5%

player_team
Real number (ℝ)

ZEROS

Distinct	16
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.002442471

Minimum	-1
Maximum	14
Zeros	623788
Zeros (%)	1.9%
Negative	8
Negative (%)	< 0.1%
Memory size	245.7 MiB

Quantile statistics

Minimum	-1
5-th percentile	1
Q1	1
median	2
Q3	3
95-th percentile	3
Maximum	14
Range	15
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	0.8897006936
Coefficient of variation (CV)	0.4443077425
Kurtosis	4.528491626
Mean	2.002442471
Median Absolute Deviation (MAD)	1
Skewness	0.8715270006
Sum	64479014
Variance	0.7915673242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
2	13759369	42.7%
1	8747230	27.2%
3	8650787	26.9%
0	623788	1.9%
4	143234	0.4%
5	100843	0.3%
6	77251	0.2%
7	75818	0.2%
8	10792	< 0.1%
9	8393	< 0.1%
Other values (6)	2678	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1	8	< 0.1%
0	623788	1.9%
1	8747230	27.2%
2	13759369	42.7%
3	8650787	26.9%
4	143234	0.4%
5	100843	0.3%
6	77251	0.2%
7	75818	0.2%
8	10792	< 0.1%

Value	Count	Frequency (%)
14	1	< 0.1%
13	8	< 0.1%
12	168	< 0.1%
11	373	< 0.1%
10	2120	< 0.1%
9	8393	< 0.1%
8	10792	< 0.1%
7	75818	0.2%
6	77251	0.2%
5	100843	0.3%

player_starting_spot
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	30
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.884059355

Minimum	0
Maximum	32
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	245.7 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	3
Q3	6
95-th percentile	10
Maximum	32
Range	32
Interquartile range (IQR)	5

Descriptive statistics

Standard deviation	2.977006983
Coefficient of variation (CV)	0.7664679428
Kurtosis	0.3707809682
Mean	3.884059355
Median Absolute Deviation (MAD)	2
Skewness	1.035193478
Sum	125067422
Variance	8.862570579
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
1	8851231	27.5%
2	5706807	17.7%
3	3488108	10.8%
4	3013535	9.4%
5	2454296	7.6%
6	2297720	7.1%
7	1866976	5.8%
8	1767178	5.5%
9	774804	2.4%
10	725738	2.3%
Other values (20)	1253790	3.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
1	8851231	27.5%
2	5706807	17.7%
3	3488108	10.8%
4	3013535	9.4%
5	2454296	7.6%
6	2297720	7.1%
7	1866976	5.8%
8	1767178	5.5%
9	774804	2.4%

Value	Count	Frequency (%)
32	1	< 0.1%
31	5	< 0.1%
30	1	< 0.1%
29	1	< 0.1%
28	1	< 0.1%
27	1	< 0.1%
26	1	< 0.1%
24	1	< 0.1%
22	1	< 0.1%
20	1	< 0.1%

player_result
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	245.7 MiB

UNKNOWN	22531157
DEFEAT	5598605
VICTORY	3924193
CONFLICTING	142686
DRAW	3542

Length

Max length	11
Median length	7
Mean length	6.843526138
Min length	4

Characters and Unicode

Total characters	220362794
Distinct characters	17
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	UNKNOWN
2nd row	UNKNOWN
3rd row	DEFEAT
4th row	DEFEAT
5th row	DEFEAT

Common Values

Value	Count	Frequency (%)
UNKNOWN	22531157	70.0%
DEFEAT	5598605	17.4%
VICTORY	3924193	12.2%
CONFLICTING	142686	0.4%
DRAW	3542	< 0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
unknown	22531157	70.0%
defeat	5598605	17.4%
victory	3924193	12.2%
conflicting	142686	0.4%
draw	3542	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
N	67878843	30.8%
O	26598036	12.1%
W	22534699	10.2%
U	22531157	10.2%
K	22531157	10.2%
E	11197210	5.1%
T	9665484	4.4%
F	5741291	2.6%
A	5602147	2.5%
D	5602147	2.5%
Other values (7)	20480623	9.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	220362794	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	67878843	30.8%
O	26598036	12.1%
W	22534699	10.2%
U	22531157	10.2%
K	22531157	10.2%
E	11197210	5.1%
T	9665484	4.4%
F	5741291	2.6%
A	5602147	2.5%
D	5602147	2.5%
Other values (7)	20480623	9.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	220362794	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	67878843	30.8%
O	26598036	12.1%
W	22534699	10.2%
U	22531157	10.2%
K	22531157	10.2%
E	11197210	5.1%
T	9665484	4.4%
F	5741291	2.6%
A	5602147	2.5%
D	5602147	2.5%
Other values (7)	20480623	9.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	220362794	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	67878843	30.8%
O	26598036	12.1%
W	22534699	10.2%
U	22531157	10.2%
K	22531157	10.2%
E	11197210	5.1%
T	9665484	4.4%
F	5741291	2.6%
A	5602147	2.5%
D	5602147	2.5%
Other values (7)	20480623	9.3%

player_is_computer
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	30.7 MiB

False	32198355
True	1828

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	32198355	> 99.9%
True	1828	< 0.1%

before_rating
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	32875
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	698.0673791

Minimum	-6146
Maximum	49730
Zeros	5175780
Zeros (%)	16.1%
Negative	1438957
Negative (%)	4.5%
Memory size	245.7 MiB

Quantile statistics

Minimum	-6146
5-th percentile	0
Q1	227.5
median	741.2
Q3	1071.4
95-th percentile	1553.8
Maximum	49730
Range	55876
Interquartile range (IQR)	843.9

Descriptive statistics

Standard deviation	527.747313
Coefficient of variation (CV)	0.7560119966
Kurtosis	8.53581572
Mean	698.0673791
Median Absolute Deviation (MAD)	391.6
Skewness	0.2102912825
Sum	2.247789735 × 10¹⁰
Variance	278517.2264
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	5175780	16.1%
477.9	61239	0.2%
-53.1	50703	0.2%
-54.6	23814	0.1%
472.9	23226	0.1%
343.7	21154	0.1%
704.1	12498	< 0.1%
337.6	12037	< 0.1%
-44.7	11436	< 0.1%
1142.4	9729	< 0.1%
Other values (32865)	26798567	83.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6146	1	< 0.1%
-1500	7	< 0.1%
-1201.8	16	< 0.1%
-1161.2	1	< 0.1%
-1122.5	8	< 0.1%
-1081.6	2	< 0.1%
-1072.1	1	< 0.1%
-1070.7	1	< 0.1%
-1020.4	9	< 0.1%
-1018.6	1	< 0.1%

Value	Count	Frequency (%)
49730	1	< 0.1%
49700	2	< 0.1%
49682	1	< 0.1%
3056.9	3	< 0.1%
3056.8	1	< 0.1%
3050	1	< 0.1%
3047.5	1	< 0.1%
3046.4	2	< 0.1%
3046.3	3	< 0.1%
3045.7	1	< 0.1%

after_rating
Real number (ℝ)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	33040
Distinct (%)	0.2%
Missing	18327390
Missing (%)	56.9%
Infinite	0
Infinite (%)	0.0%
Mean	915.8573469

Minimum	-10013.6
Maximum	49735.8
Zeros	165
Zeros (%)	< 0.1%
Negative	393198
Negative (%)	1.2%
Memory size	245.7 MiB

Quantile statistics

Minimum	-10013.6
5-th percentile	144.9
Q1	636.1
median	920.6
Q3	1206
95-th percentile	1654.9
Maximum	49735.8
Range	59749.4
Interquartile range (IQR)	569.9

Descriptive statistics

Standard deviation	448.5193635
Coefficient of variation (CV)	0.4897262277
Kurtosis	40.55911793
Mean	915.8573469
Median Absolute Deviation (MAD)	284.9
Skewness	0.3065184828
Sum	1.270549939 × 10¹⁰
Variance	201169.6195
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
477.9	6402	< 0.1%
-53.1	5939	< 0.1%
472.9	2897	< 0.1%
704.1	2434	< 0.1%
-54.6	2411	< 0.1%
839.2	1815	< 0.1%
930.9	1680	< 0.1%
699.6	1653	< 0.1%
343.7	1613	< 0.1%
835.9	1566	< 0.1%
Other values (33030)	13844383	43.0%
(Missing)	18327390	56.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10013.6	1	< 0.1%
-5593.6	1	< 0.1%
-1937	1	< 0.1%
-1630.9	1	< 0.1%
-1582.1	1	< 0.1%
-1580.7	1	< 0.1%
-1526.5	1	< 0.1%
-1410.9	1	< 0.1%
-1388.2	1	< 0.1%
-1356.5	1	< 0.1%

Value	Count	Frequency (%)
49735.8	1	< 0.1%
49730	1	< 0.1%
49694.8	1	< 0.1%
49682	1	< 0.1%
3056.9	1	< 0.1%
3056.8	1	< 0.1%
3050	1	< 0.1%
3047.5	1	< 0.1%
3046.4	1	< 0.1%
3046.3	1	< 0.1%

leaderboard_ids
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	18571835
Missing (%)	57.7%
Memory size	245.7 MiB

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	game_id	game_start_time	game_duration_minutes	game_validity	game_featuremod_name	game_total_players	map_id	map_name	map_width	map_height	player_id	player_login	player_faction	player_team	player_starting_spot	player_result	player_is_computer	before_rating	after_rating	leaderboard_ids
0	17405720	2022-06-30 23:59:58 UTC	30.7	UNKNOWN_RESULT	FAF	1	21833.0	Hold the line	2048.0	2048.0	431007	Walgreens	UEF	3	1	UNKNOWN	False	0.0	NaN	NaN
1	17405711	2022-06-30 23:59:44 UTC	30.2	COOP_NOT_RANKED	Coop	1	NaN	NaN	NaN	NaN	96808	Starcruiser	Cybran	1	1	UNKNOWN	False	0.0	NaN	NaN
2	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	303409	ourubapu	UEF	3	3	DEFEAT	False	163.3	159.7	1
3	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	436692	Enzord_Rocka	UEF	2	11	DEFEAT	False	686.7	692.4	1
4	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	17943	Defiant	UEF	3	5	DEFEAT	False	1082.8	1078.0	1
5	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	359511	Haler	Aeon	2	8	DEFEAT	False	792.7	798.2	1
6	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	258970	Envoy666	Cybran	3	2	DEFEAT	False	1045.6	1040.5	1
7	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	332940	Sinidas	Aeon	2	12	DEFEAT	False	750.0	754.6	1
8	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	356873	SPACER-BT	Seraphim	2	9	DEFEAT	False	1045.9	1051.6	1
9	17405650	2022-06-30 23:58:34 UTC	48.0	VALID	FAF	12	14570.0	Desert Gap	1024.0	1024.0	248696	McLeod	Cybran	2	10	DEFEAT	False	778.6	783.9	1

Last rows

	game_id	game_start_time	game_duration_minutes	game_validity	game_featuremod_name	game_total_players	map_id	map_name	map_width	map_height	player_id	player_login	player_faction	player_team	player_starting_spot	player_result	player_is_computer	before_rating	after_rating	leaderboard_ids
32200173	547	2012-02-21 21:44:01 UTC	19.2	TOO_MANY_DESYNCS	FAF	4	81.0	Island Zero	512.0	512.0	13942	Lunagirl	Cybran	3	2	UNKNOWN	False	241.7	NaN	NaN
32200174	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	11364	Leibnitz	Cybran	2	5	UNKNOWN	False	1210.3	NaN	NaN
32200175	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	12321	tiib	Aeon	3	4	UNKNOWN	False	1069.3	NaN	NaN
32200176	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	6526	zanareno	Aeon	2	1	UNKNOWN	False	1263.8	NaN	NaN
32200177	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	673	DK_Skoldkop	Seraphim	3	6	UNKNOWN	False	1196.8	NaN	NaN
32200178	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	13250	ReDgO	UEF	3	2	UNKNOWN	False	621.7	NaN	NaN
32200179	535	2012-02-21 21:36:34 UTC	36.5	TOO_MANY_DESYNCS	FAF	6	136.0	IsisFields3v3	512.0	512.0	6529	mogwai2000	UEF	2	3	UNKNOWN	False	1104.9	NaN	NaN
32200180	536	2012-02-21 21:29:33 UTC	15.4	TOO_MANY_DESYNCS	FAF	3	181.0	Sludge2	512.0	512.0	10257	jarek	Aeon	1	2	UNKNOWN	False	1061.4	NaN	NaN
32200181	536	2012-02-21 21:29:33 UTC	15.4	TOO_MANY_DESYNCS	FAF	3	181.0	Sludge2	512.0	512.0	10259	kipex	Seraphim	1	1	UNKNOWN	False	895.3	NaN	NaN
32200182	536	2012-02-21 21:29:33 UTC	15.4	TOO_MANY_DESYNCS	FAF	3	181.0	Sludge2	512.0	512.0	10255	mat123456	Seraphim	1	3	UNKNOWN	False	989.8	NaN	NaN

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Dash Punctuation

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Math Symbol

Open Punctuation

Close Punctuation

Space Separator

Connector Punctuation

Dash Punctuation

Modifier Symbol

Control

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter